Configuring: Statistics

Select the statistics to be calculated, the fields on which they must be calculated, and whether they must be calculated using an index or a time base.

Worked example: Statistics

Steps to configure

  1. Base selection:Select the base to be used to calculate the statistics.

  2. Field selection: Select the fields for which you would like to calculate the statistics.

  3. Statistics selection: Select the statistics that you want calculated.

  4. Execution: A new dataset is created, containing the statistics for each of the selected fields.

Step 1: Base selection

Select whether the statistics must be calculated using an index or a time base.

  • Index base: all statistics are calculated over the same interval.

  • Time based: all statistics are calculated over potentially varying intervals.

  • Default settings: index-based is selected.

  • Minimum configuration: if time is chosen as base, there has to be at least one timestamp field. Select the relevant timestamp field from the drop down list.

Step 2: Field selection

Select the fields for which you would like to calculate the statistics.

  • Default settings: all the fields are selected by default.

  • Minimum configuration: at least one field has to be selected.

Step 3: Statistics selection page

Select the statistics to be calculated for the selected fields.

  • Average: the sum of all the values in the window, divided by the count of values.

  • Kurtosis: a measure of whether the data are peaked or flat relative to a normal distribution. Data sets with high kurtosis tend to have a distinct peak near the mean, decline rather rapidly, and have heavy tails. Data sets with low kurtosis tend to have a flat top near the mean rather than a sharp peak.

  • Maximum: the greatest value in the window.

  • Minimum: the smallest value in the window.

  • Skew: a measure of the asymmetry of the distribution of data values. For example, in a histogram, skew occurs if the values on one side of the histogram tend to extend further from the median than the values on the other side.

  • Standard deviation: measure of statistical dispersion; it is calculated as the positive square root of the variance.

  • Variance: measure of statistical dispersion, averaging the squared distance of its possible values from the mean.  

  • Default: all the statistics are selected by default.

  • Minimum configuration: at least one statistic has to be selected.

Step 4: Execute

A new dataset is created containing the selected statistics for the selected fields.


Related topics:

  

CSense 2023- Last updated: June 24,2025